Hi Guest

HomePage

1 1

To improves our performance please Like Share Subscribe(Will boost us)

With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Question Posted on 23 Sep 2023

Home >> DataBase >> MySQL MCQ >> With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

With MySQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
Choose the correct option from below list
(1)SELECT * FROM Persons ORDER BY FirstName DESC
(2)SELECT * FROM Persons ORDER FirstName DESC
(3)SELECT * FROM Persons SORT BY 'FirstName' DESC
(4)SELECT * FROM Persons SORT 'FirstName' DESC

Answer:-(1)SELECT * FROM Persons ORDER BY FirstName DESC
0
0



Most Visited Questions:-

Deep Learning Questions Answers
Below are the different Deep Leaning Questions and answer a More...

Continuous Integration Questions Answers
Below are the 20 odd questions for CI or Continuous Integra More...

Derived relationships in Association Rule Mining are represented in the form of __________.
Derived relationships in Association Rule Mining are repres More...

What is Gulpjs and some multiple choice questions on Gulp
Gulpjs is an open source whihc helps in building Javascript More...

Microservices Architecture Questions Answers
Below are the different questions on Microservices Architec More...




Other Important Questions
With MySQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
With MySQL, how can you insert a new record into the "Persons" table?
Which MySQL statement is used to create a database table called "Customers"?
The NOT NULL constraint enforces a column to not accept NULL values.
With MySQL, how can you return the number of records in the "Persons" table?






Most Visited Questions
Top Searches:asp net questions vb net questions sql query uddl questions class javascript Questions sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |
     
 
Privacy policy | Terms and Conditions | Blog


If the copyright of any questions or content or syntax belong to you email us we will remove that(info@crackyourinterview.com or crackyourinterview2018@gmail.com)
 

1
Home About Us GroupChat
 
Sitemap Feedback Contact us